package com.warehouse.mapper;

import com.warehouse.entity.Customer;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;

@Mapper
public interface CustomerMapper {
    
    List<Customer> selectAll();
    
    List<Customer> selectActive();
    
    Customer selectById(@Param("id") Long id);
    
    List<Customer> selectByName(@Param("customerName") String customerName);
    
    List<Customer> selectByPhone(@Param("phone") String phone);
    
    int insert(Customer customer);
    
    int update(Customer customer);
    
    int deleteById(@Param("id") Long id);
    
    int updateStatus(@Param("id") Long id, @Param("status") String status);
    
    long countAll();
} 